{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Coversheet","Modelling inputs","Growth (Residential)","Growth (Non-Residential)","Growth (Impervious Area)","BAICR Charge Lookup","Adopted Charge Revenue Forecast","LGIP Cash Flow Analysis"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coversheet","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Brisbane City Council"]
[null,"Local Government Infrastructure Plan (LGIP)"]
[]
[]
[null,"Anticipated Charges Revenue and Future Cash Flows Model"]
[]
[null,"Version:","LGIP A1b draft"]
[null,"Date:","2022-08-22"]
[null,"Author:","Brisbane City Council"]
[]
[]
[null,"Model flow diagram (click to follow)"]

{"sheet":"Modelling inputs","index":1,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[15,1,23,1]]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"}]
["Input"]
["Formula",null,"General modelling inputs"]
[]
[null,null,"Model parameters",null,"Value",null,"BCC Comment/Source"]
[]
[null,null,"Modelling timframes"]
[]
[null,null,"Modelling start year:",null,2021,null,"Base values for all costs"]
[null,null,"Modelling end year:",null,2036,null,"N/A"]
[null,null,"Modelling term (years):",null,{"$f":"E12-E11","v":15},null,"N/A"]
[]
[null,null,"Financial inputs"]
[]
[null,null,"Average 10 Year Bond Rate:",null,null,null,"Not used"]
[null,null,"Basic Margin on 10 Yr. Bond Rate:",null,null,null,"Not used"]
[]
[null,null,"Calculated WACC:",null,{"$f":"E18+E17","v":0},null,"Not used"]
[]
[null,null,"Optional WACC over ride:",null,5.91E-2,null,"Corporately endorsed WACC rate"]
[]
[null,null,"Applied WACC:",null,{"$f":"IF(OR(WACC_override=\"\",WACC_override=0),WACC_Calculated,WACC_override)","v":5.91E-2},null,"Defaults to caculated WACC if no override value is entered"]
[]
[null,null,"Charge inputs"]
[]
[null,null,"Adopted Charging Source (Default)",null,"BAICR10",null,"Brisbane Adopted Infrastructure Charges Resolution (No.10) 2021"]
[]
[null,null,"Escalation Rates - PPI",null,{"$f":"(E31/E41)^(1/(C31-C41))-1","v":1.8205372333204517E-2},null,"ten (10) yr. average Roads and Bridges Index between 2011 - 2021  (Mar Qtr.)"]
[null,null,2021,null,119.7807,null,"three (3) yr. rolling average Roads and Bridges Index (ABS 6427, Table 17, Index 3101, Series ID: A2333727L)"]
[null,null,{"$f":"C31-1","v":2020}]
[null,null,{"$f":"C32-1","v":2019}]
[null,null,2018]
[null,null,2017]
[null,null,2016]
[null,null,2015]
[null,null,2014]
[null,null,2013]
[null,null,2012]
[null,null,{"$f":"C40-1","v":2011},null,100.0076,null,"three (3) yr. rolling average Roads and Bridges Index (ABS 6427, Table 17, Index 3101, Series ID: A2333727L)"]
[null,null,{"$f":"C41-1","v":2010}]
[null,null,2009]
[null,null,2008]
[null,null,2007]
[null,null,2006,null,75.123599999999996,null,"three (3) yr. rolling average Roads and Bridges Index (ABS 6427, Table 17, Index 3101, Series ID: A2333727L)"]
[]
[null,null,"Network expenditure inputs"]
[]
[null,null,"Local Roads",null,null,null,"Sourced from LGIP Local Roads network financial model"]
[]
[null,null,"Pathways",null,null,null,"Sourced from LGIP Active and Public Transport network financial model"]
[]
[null,null,"Ferry Terminals",null,null,null,"Sourced from LGIP Active and Public Transport network financial model"]
[]
[null,null,"Public Parks",null,null,null,"Sourced from LGIP Public Parks network financial model"]
[]
[null,null,"Land for Community Facilities",null,null,null,"Sourced from LGIP Land for Community Facilities network financial model"]
[]
[null,null,"Stormwater",null,null,null,"Sourced from LGIP Stormwater network financial model"]

{"sheet":"Growth (Residential)","index":2,"n_rows":57,"n_cols":22,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"},null,null,"Input"]
[null,null,null,"Formula"]
[1.1000000000000001,"Anticipated Residential Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2021,2026,2031,2036]
[null,"Attached Dwelling","Number of dwellings: 1 or 2 bedroom dwelling",117020.11202931163,127933.99215436389,141843.37688922521,159073.0881060953]
[null,"Attached Dwelling","Number of dwellings: 3 or more bedroom dwelling",56624.887970688382,61906.007845636108,68636.623110774803,76973.911893904689]
[null,"Excluded Attached Dwelling(4)",null,{"$f":"D11-D8-D9","v":8453.9999999999927},{"$f":"E11-E8-E9","v":16010},19244.999999999985,21860.000000000015]
[null,"Total Attached Dwelling",null,182099,205850,229725,257907]
[null,"Detached Dwelling","Number of dwellings: 1 or 2 bedroom dwelling",24796.506454765211,25088.048706475336,25283.148022424524,25575.164583654787]
[null,"Detached Dwelling","Number of dwellings: 3 or more bedroom dwelling",288878.49354523479,292274.95129352465,294547.85197757545,297949.83541634522]
[null,"Excluded Detached Dwelling(4)",null,{"$f":"D15-D12-D13","v":968},{"$f":"E15-E12-E13","v":1000},1020,1020]
[null,"Total Detached Dwelling",null,314643,318363,320851,324545]
[null,"Short term accommodation","Number of bedrooms: Bedroom that is not within a suite",10737.995354590346,11408.792758918335,11778.159803735842,12142.432787356538]
[null,"Short term accommodation","Number of suites: Suite with 1 or 2 bedrooms",5642.5511711193376,5995.0386284506239,6189.131881658911,6380.548331607125]
[null,"Short term accommodation","Number of suites: Suite with 3 or more bedrooms",1685.7790763691476,1791.0888843320886,1849.0765454449679,1906.2644798401732]
[null,"Long term accommodation","Number of bedrooms: Bedroom that is not within a suite",506.00395722226392,537.61378101859168,555.01937490956448,572.18492258717993]
[null,"Long term accommodation","Number of suites: Suite with 1 or 2 bedrooms",1659.8914126134266,1763.5840306747134,1820.6812043601988,1876.9909323301019]
[null,"Long term accommodation","Number of suites: Suite with 3 or more bedrooms",338.32813610351371,359.46333201439165,371.10118989051267,382.57854627887906]
[null,"Total Other",null,{"$f":"SUM(D16:D21)","v":20570.549108018036},{"$f":"SUM(E16:E21)","v":21855.581415408742},22563.17,23261.000000000004]
[]
[1.2,"Anticipated Residential Growth - Annualised (4)"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,null,"Charge Code (3)","Applied Charge"]
[null,{"$f":"B8","v":"Attached Dwelling"},"Number of dwellings: 1 or 2 bedroom dwelling",117020.11202931163,{"$f":"($E8-$D8)/5","v":2182.7760250104534},2182.7760250104534,2182.7760250104534,2182.7760250104534,2182.7760250104534,{"$f":"($F8-$E8)/5","v":2781.8769469722638},2781.8769469722638,2781.8769469722638,2781.8769469722638,2781.8769469722638,{"$f":"($G8-$F8)/5","v":3445.9422433740169},3445.9422433740169,3445.9422433740169,3445.9422433740169,3445.9422433740169,null,"B07",{"$f":"VLOOKUP(U27,'BAICR Charge Lookup'!A:F,6,FALSE)","v":10907.66}]
[null,"Attached Dwelling","Number of dwellings: 3 or more bedroom dwelling",56624.887970688382,1056.2239749895452,1056.2239749895452,1056.2239749895452,1056.2239749895452,1056.2239749895452,1346.1230530277389,1346.1230530277389,1346.1230530277389,1346.1230530277389,1346.1230530277389,1667.4577566259773,1667.4577566259773,1667.4577566259773,1667.4577566259773,1667.4577566259773,null,"B08",{"$f":"VLOOKUP(U28,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15270.71}]
[null,{"$f":"B12","v":"Detached Dwelling"},"Number of dwellings: 1 or 2 bedroom dwelling",24796.506454765211,{"$f":"($E12-$D12)/5","v":58.308450342025026},58.308450342025026,58.308450342025026,58.308450342025026,58.308450342025026,{"$f":"($F12-$E12)/5","v":39.019863189837636},39.019863189837636,39.019863189837636,39.019863189837636,39.019863189837636,{"$f":"($G12-$F12)/5","v":58.403312246052522},58.403312246052522,58.403312246052522,58.403312246052522,58.403312246052522,null,"A01",{"$f":"VLOOKUP(U29,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15270.71}]
[null,"Detached Dwelling","Number of dwellings: 3 or more bedroom dwelling",288878.49354523479,679.29154965797204,679.29154965797204,679.29154965797204,679.29154965797204,679.29154965797204,454.58013681016166,454.58013681016166,454.58013681016166,454.58013681016166,454.58013681016166,680.39668775395262,680.39668775395262,680.39668775395262,680.39668775395262,680.39668775395262,null,"A01",{"$f":"VLOOKUP(U30,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15270.71}]
[null,{"$f":"B16","v":"Short term accommodation"},"Number of bedrooms: Bedroom that is not within a suite",10737.995354590346,{"$f":"($E16-$D16)/5","v":134.15948086559766},134.15948086559766,134.15948086559766,134.15948086559766,134.15948086559766,{"$f":"($F16-$E16)/5","v":73.873408963501419},73.873408963501419,73.873408963501419,73.873408963501419,73.873408963501419,{"$f":"($G16-$F16)/5","v":72.85459672413927},72.85459672413927,72.85459672413927,72.85459672413927,72.85459672413927,null,"C01",{"$f":"VLOOKUP(U31,'BAICR Charge Lookup'!A:F,6,FALSE)","v":5453.8}]
[null,"Short term accommodation","Number of suites: Suite with 1 or 2 bedrooms",5642.5511711193376,70.497491466257273,70.497491466257273,70.497491466257273,70.497491466257273,70.497491466257273,38.818650641657406,38.818650641657406,38.818650641657406,38.818650641657406,38.818650641657406,38.283289989642796,38.283289989642796,38.283289989642796,38.283289989642796,38.283289989642796,null,"C02",{"$f":"VLOOKUP(U32,'BAICR Charge Lookup'!A:F,6,FALSE)","v":5453.8}]
[null,"Short term accommodation","Number of suites: Suite with 3 or more bedrooms",1685.7790763691476,21.061961592588204,21.061961592588204,21.061961592588204,21.061961592588204,21.061961592588204,11.597532222575865,11.597532222575865,11.597532222575865,11.597532222575865,11.597532222575865,11.437586879041055,11.437586879041055,11.437586879041055,11.437586879041055,11.437586879041055,null,"C03",{"$f":"VLOOKUP(U33,'BAICR Charge Lookup'!A:F,6,FALSE)","v":7635.32}]
[null,"Long term accommodation","Number of bedrooms: Bedroom that is not within a suite",506.00395722226392,6.3219647592655521,6.3219647592655521,6.3219647592655521,6.3219647592655521,6.3219647592655521,3.4811187781945589,3.4811187781945589,3.4811187781945589,3.4811187781945589,3.4811187781945589,3.4331095355230898,3.4331095355230898,3.4331095355230898,3.4331095355230898,3.4331095355230898,null,"D01",{"$f":"VLOOKUP(U34,'BAICR Charge Lookup'!A:F,6,FALSE)","v":10907.66}]
[null,"Long term accommodation","Number of suites: Suite with 1 or 2 bedrooms",1659.8914126134266,20.73852361225736,20.73852361225736,20.73852361225736,20.73852361225736,20.73852361225736,11.419434737097072,11.419434737097072,11.419434737097072,11.419434737097072,11.419434737097072,11.261945593980636,11.261945593980636,11.261945593980636,11.261945593980636,11.261945593980636,null,"D02",{"$f":"VLOOKUP(U35,'BAICR Charge Lookup'!A:F,6,FALSE)","v":10907.66}]
[null,"Long term accommodation","Number of suites: Suite with 3 or more bedrooms",338.32813610351371,4.2270391821755879,4.2270391821755879,4.2270391821755879,4.2270391821755879,4.2270391821755879,2.3275715752242037,2.3275715752242037,2.3275715752242037,2.3275715752242037,2.3275715752242037,2.2954712776732777,2.2954712776732777,2.2954712776732777,2.2954712776732777,2.2954712776732777,null,"D03",{"$f":"VLOOKUP(U36,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15270.71}]
[]
[1.3,"Anticipated Revenue - Applied Charge (3)"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,{"$f":"B8","v":"Attached Dwelling"},{"$f":"C8","v":"Number of dwellings: 1 or 2 bedroom dwelling"},"N/A",{"$f":"E27*$V27*(1+PPI)^(E40-BaseYear)","v":24242430.05974533},24683772.525244664,25133149.794654865,25590708.144572765,26056596.514615081,33812852.714650884,34428428.287968904,35055210.643798418,35693403.80578769,36343215.511911474,45838332.661397129,46672836.574631162,47522532.942319132,48387698.348751031,49268614.413536824]
[null,{"$f":"B9","v":"Attached Dwelling"},{"$f":"C9","v":"Number of dwellings: 3 or more bedroom dwelling"},"N/A",{"$f":"E28*$V28*(1+PPI)^(E$40-BaseYear)","v":16422929.747344371},{"$f":"F28*$V28*(1+PPI)^(F40-BaseYear)","v":16721915.298196837},17026343.992324818,17336314.924178313,17651928.992258672,22906371.32174724,23323390.340462286,23748001.345683075,24180342.552350678,24620554.691660654,31052980.876020107,31618311.954923939,32193935.096610744,32780037.671915561,33376810.462829251]
[null,{"$f":"B12","v":"Detached Dwelling"},{"$f":"C12","v":"Number of dwellings: 1 or 2 bedroom dwelling"},"N/A",906621.70743953565,{"$f":"F29*$V29*(1+PPI)^(F$40-BaseYear)","v":923127.0931888381},939932.96563120955,957044.79523877904,974468.15207565657,663983.48437747126,676071.55093366164,688379.6852422962,700911.89371874637,713672.25571666774,1087641.9094074254,1107442.8353333853,1127604.2444883694,1148132.6996037818,1169034.8828879958]
[null,{"$f":"B13","v":"Detached Dwelling"},{"$f":"C13","v":"Number of dwellings: 3 or more bedroom dwelling"},"N/A",10562113.398446564,{"$f":"F30*$V30*(1+PPI)^(F$40-BaseYear)","v":10754400.605490813},10950188.472734213,11149540.730999105,11352522.271351174,7735385.9930141568,7876211.5751580335,8019600.9394588834,8165600.7605254501,8314258.5626951149,12670992.86262168,12901673.005517086,13136552.766303781,13375708.600589128,13619218.355883298]
[null,{"$f":"B16","v":"Short term accommodation"},"Number of bedrooms: Bedroom that is not within a suite","N/A",744999.46494481363,{"$f":"F31*$V31*(1+PPI)^(F$40-BaseYear)","v":758562.4575921722},772372.36957062827,786433.6961385411,800751.01439212158,448951.73372775968,457125.06719991117,465447.19925112685,473920.83881494089,482548.74414203153,484557.5803152296,493379.13148174511,502361.28227180341,511506.95646134764,520819.13105475064]
[null,"Short term accommodation","Number of suites: Suite with 1 or 2 bedrooms","N/A",391478.80629419629,{"$f":"F32*$V32*(1+PPI)^(F$40-BaseYear)","v":398605.82372334058},405862.59115840768,413251.47074656573,420774.86763875134,235913.0403086555,240207.92504573285,244580.99975857697,249033.68792480929,253567.43893699153,254623.03269796495,259258.53981284119,263978.43806069694,268784.26381352963,273677.58141356119]
[null,"Short term accommodation","Number of suites: Suite with 3 or more bedrooms","N/A",163742.51019978509,{"$f":"F33*$V33*(1+PPI)^(F$40-BaseYear)","v":166723.50356474571},169758.76702383824,172849.288584333,175996.0742405403,98674.545819403967,100470.95266585606,102300.06376780977,104162.47451841332,106058.79115016897,106500.31076603095,108439.18857712856,110413.36438068577,112423.48078979793,114470.19211657107]
[null,"Long term accommodation","Number of bedrooms: Bedroom that is not within a suite","N/A",70213.245317249588,{"$f":"F34*$V34*(1+PPI)^(F$40-BaseYear)","v":71491.503590972745},72793.033032507024,74118.257302127095,75467.607773000564,42311.920610797468,43082.224879650021,43866.552824526909,44665.159751671614,45478.30561527286,45667.630458669155,46499.026674744426,47345.558768489769,48207.502294193735,49085.137822713339]
[null,"Long term accommodation","Number of suites: Suite with 1 or 2 bedrooms","N/A",230326.97924658505,{"$f":"F35*$V35*(1+PPI)^(F$40-BaseYear)","v":234520.16766215145},238789.69463408642,243136.94993423222,247563.34863574465,138799.69251345939,141326.59259540119,143899.49583418362,146519.23973440536,149186.67704774829,149807.73677912436,152535.04240558305,155311.99964643785,158139.51242781579,161018.50113215556]
[null,"Long term accommodation","Number of suites: Suite with 3 or more bedrooms","N/A",65725.044282230781,{"$f":"F36*$V36*(1+PPI)^(F$40-BaseYear)","v":66921.593185005157},68139.925706069422,69380.438424305321,70643.535138460764,39607.239962282321,40328.30451288625,41062.496312110212,41810.054346403012,42571.221953050801,42748.44469300138,43526.696045302881,44319.115753241844,45125.961757008001,45947.496692688277]
[null,"Total","N/A","N/A",{"$f":"SUM(E41:E50)","v":53800580.963260666},54780040.571439542,55777331.606470637,56792778.69611907,57826712.378119208,66122851.686732113,67326642.821422309,68552349.421930999,69800370.467473209,71071112.200829163,91733853.045156345,93403901.995402947,95104354.808603406,96835764.998403206,98598696.155369818]
[]
["Notes:"]
["(1) Attached and detached dwellings growth figures are based on the predicted residential dwelling supply. Short and long term accommodation growth figures are based on land use counts and growth rates sourced from LGIP planning assumptions."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) To reflect the development practice,  charges apply when a subdivision of residential lots occurs for detached dwellings. "]
["(4) Planning Scheme zones exlude Priority Development Areas, Special Purpose Zones for Airport, Port and Southbank"]

{"sheet":"Growth (Non-Residential)","index":3,"n_rows":62,"n_cols":22,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"},null,null,"Input"]
[null,null,null,"Formula"]
[2.1,"Anticipated Non Residential Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2021,2026,2031,2036]
[null,"Food Services, Arts & Recreation","m2 GFA",1500534,1590104,1673068,1741945]
[null,"Community - Education","m2 GFA",3667784,4113498,4519897,4880222]
[null,"Community - Health","m2 GFA",948051,1063259,1168305,1261442]
[null,"Community - Other","m2 GFA",1119039,1255026,1379018,1488953]
[null,"Industry - General","m2 GFA",507969,534186,552178,563738]
[null,"Industry - Heavy","m2 GFA",294936,310158,320605,327317]
[null,"Industry - Light","m2 GFA",6160939,6478910,6697124,6837334]
[null,"Industry - Other","m2 GFA",117140,123186,127335,130000]
[null,"Office","m2 GFA",5970560,6394623,6826675,7189283]
[null,"Retail","m2 GFA",3391391,3593829,3781338,3937009]
[null,"Showroom, Retail Warehouse & Bulky Goods","m2 GFA",947121,1003656,1056022,1099497]
[null,"Warehouse, Bulk Stores & Logistics","m2 GFA",8377728,8810108,9106839,9297499]
[null,"Rural","m2 GFA",5710,6012,6234,6417]
[null,"Excluded(3)","m2 GFA",3294176,3477215,3624551,3760113]
[null,"Total","m2 GFA",36303078,38753770,40839189,42520769]
[]
[2.2000000000000002,"Anticipated Non Residential Growth - Annualised  (3)"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,null,"Charge Code","Applied Charge"]
[null,{"$f":"B8","v":"Food Services, Arts & Recreation"},"m2 GFA",1500534,{"$f":"($E8-$D8)/5","v":17914},17914,17914,17914,17914,{"$f":"($F8-$E8)/5","v":16592.8},16592.8,16592.8,16592.8,16592.8,16592.8,16592.8,16592.8,16592.8,16592.8,null,"G02",{"$f":"VLOOKUP(U27,'BAICR Charge Lookup'!A:F,6,FALSE)","v":157.05000000000001}]
[null,"Community - Education","m2 GFA",3667784,89142.8,89142.8,89142.8,89142.8,89142.8,{"$f":"($F9-$E9)/5","v":81279.8},81279.8,81279.8,81279.8,81279.8,81279.8,81279.8,81279.8,81279.8,81279.8,null,"I03",{"$f":"VLOOKUP(U28,'BAICR Charge Lookup'!A:F,6,FALSE)","v":113.45}]
[null,"Community - Health","m2 GFA",948051,23041.599999999999,23041.599999999999,23041.599999999999,23041.599999999999,23041.599999999999,{"$f":"($F10-$E10)/5","v":21009.200000000001},21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,21009.200000000001,null,"P03",{"$f":"VLOOKUP(U29,'BAICR Charge Lookup'!A:F,6,FALSE)","v":113.45}]
[null,"Community - Other","m2 GFA",1119039,27197.4,27197.4,27197.4,27197.4,27197.4,{"$f":"($F11-$E11)/5","v":24798.400000000001},24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,24798.400000000001,null,"E02",{"$f":"VLOOKUP(U30,'BAICR Charge Lookup'!A:F,6,FALSE)","v":37.1}]
[null,"Industry - General","m2 GFA",507969,5243.4,5243.4,5243.4,5243.4,5243.4,{"$f":"($F12-$E12)/5","v":3598.4},3598.4,3598.4,3598.4,3598.4,3598.4,3598.4,3598.4,3598.4,3598.4,null,"L02",{"$f":"VLOOKUP(U31,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15.28}]
[null,"Industry - Heavy","m2 GFA",294936,3044.4,3044.4,3044.4,3044.4,3044.4,{"$f":"($F13-$E13)/5","v":2089.4},2089.4,2089.4,2089.4,2089.4,2089.4,2089.4,2089.4,2089.4,2089.4,null,"M01",{"$f":"VLOOKUP(U32,'BAICR Charge Lookup'!A:F,6,FALSE)","v":32.71}]
[null,"Industry - Light","m2 GFA",6160939,63594.2,63594.2,63594.2,63594.2,63594.2,{"$f":"($F14-$E14)/5","v":43642.8},43642.8,43642.8,43642.8,43642.8,43642.8,43642.8,43642.8,43642.8,43642.8,null,"L01",{"$f":"VLOOKUP(U33,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15.28}]
[null,"Industry - Other","m2 GFA",117140,1209.2,1209.2,1209.2,1209.2,1209.2,{"$f":"($F15-$E15)/5","v":829.8},829.8,829.8,829.8,829.8,829.8,829.8,829.8,829.8,829.8,null,"L01",{"$f":"VLOOKUP(U34,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15.28}]
[null,"Office","m2 GFA",5970560,84812.6,84812.6,84812.6,84812.6,84812.6,{"$f":"($F16-$E16)/5","v":86410.4},86410.4,86410.4,86410.4,86410.4,86410.4,86410.4,86410.4,86410.4,86410.4,null,"H01",{"$f":"VLOOKUP(U35,'BAICR Charge Lookup'!A:F,6,FALSE)","v":113.45}]
[null,"Retail","m2 GFA",3391391,40487.599999999999,40487.599999999999,40487.599999999999,40487.599999999999,40487.599999999999,{"$f":"($F17-$E17)/5","v":37501.800000000003},37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,37501.800000000003,null,"G05",{"$f":"VLOOKUP(U36,'BAICR Charge Lookup'!A:F,6,FALSE)","v":157.05000000000001}]
[null,"Showroom, Retail Warehouse & Bulky Goods","m2 GFA",947121,11307,11307,11307,11307,11307,{"$f":"($F18-$E18)/5","v":10473.200000000001},10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,10473.200000000001,null,"F06",{"$f":"VLOOKUP(U37,'BAICR Charge Lookup'!A:F,6,FALSE)","v":113.45}]
[null,"Warehouse, Bulk Stores & Logistics","m2 GFA",8377728,86476,86476,86476,86476,86476,{"$f":"($F19-$E19)/5","v":59346.2},59346.2,59346.2,59346.2,59346.2,59346.2,59346.2,59346.2,59346.2,59346.2,null,"L05",{"$f":"VLOOKUP(U38,'BAICR Charge Lookup'!A:F,6,FALSE)","v":15.28}]
[null,"Rural","m2 GFA",5710,60.4,60.4,60.4,60.4,60.4,{"$f":"($F20-$E20)/5","v":44.4},44.4,44.4,44.4,44.4,44.4,44.4,44.4,44.4,44.4,null,"N01",{"$f":"VLOOKUP(U39,'BAICR Charge Lookup'!A:F,6,FALSE)","v":0}]
[]
[2.2999999999999998,"Anticipated Revenue - Applied Charge"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,{"$f":"B8","v":"Food Services, Arts & Recreation"},"m2 GFA","N/A",{"$f":"E27*$V27*(1+PPI)^(E$43-BaseYear)","v":2864612.5798283922},2916763.9184345496,2969864.691577707,3023932.1840671175,3078983.9953884198,2903821.5518729179,2956686.7044139481,3010514.2867404404,3065321.8202449819,3121127.1453036382,3177948.4270831621,3235804.1614539335,3294713.1810105355,3354694.6612019488,3415768.1265733433]
[null,"Community - Education","m2 GFA","N/A",{"$f":"E28*$V28*(1+PPI)^(E$43-BaseYear)","v":10297366.153764326},10484833.538644945,10675713.837067645,10870069.182394208,11067962.839147387,10275416.430745944,10462484.2127464,10652957.633369727,10846898.693535076,11044370.522911433,11245437.400466902,11450164.775392149,11658619.288404707,11870868.793441193,12086982.379744409]
[null,"Community - Health","m2 GFA","N/A",{"$f":"E29*$V29*(1+PPI)^(E$43-BaseYear)","v":2661659.628916481},2710116.133485165,2759454.8067614869,2809691.7089552311,2860843.1926582791,2655989.2971787294,2704342.5712468741,2753576.1346729603,2803706.0134525076,2854748.5253402553,2906720.2851617411,2959638.2102215895,3013519.5258102529,3068381.7708110102,3124242.8034090418]
[null,"Community - Other","m2 GFA","N/A",{"$f":"E30*$V30*(1+PPI)^(E$43-BaseYear)","v":1027393.1892386681},1046097.2647813567,1065141.8549834481,1084533.159041102,1104277.4890091517,1025203.0169055637,1043867.2195454539,1062871.2109437061,1082221.1770811803,1101923.4165568221,1121984.3426379159,1142410.4853476649,1163208.4935907763,1184385.1373177422,1205947.3097285251]
[null,"Industry - General","m2 GFA","N/A",{"$f":"E31*$V31*(1+PPI)^(E$43-BaseYear)","v":81577.750993180598},83062.904324116898,84575.095424414787,86114.816526732582,87682.568825007344,61269.607375964872,62385.043390953564,63520.786333909018,64677.205900015761,65854.678514896892,67053.587457144051,68274.322983078469,69517.282453782886,70782.870464446547,72071.498976064773]
[null,"Industry - Heavy","m2 GFA","N/A",{"$f":"E32*$V32*(1+PPI)^(E$43-BaseYear)","v":101395.25728622581},103241.19569794263,105120.7401057489,107034.50231931612,108983.1052865385,76157.808691140308,77544.289954443462,78956.012625378105,80393.436233168322,81857.02867293889,83347.266358019522,84864.634375022069,86409.626641740615,87982.746067926681,89584.504718991069]
[null,"Industry - Light","m2 GFA","N/A",{"$f":"E33*$V33*(1+PPI)^(E$43-BaseYear)","v":989409.8890434691},1007422.4644636601,1025762.9655260554,1044437.3622390695,1063451.7332973417,743101.71764888847,756630.16110013018,770404.89490149089,784430.40286049584,798711.25041405694,813252.08611456398,828057.64314303512,843132.74084980995,858482.28632329591,874111.27598727215]
[null,"Industry - Other","m2 GFA","N/A",{"$f":"E34*$V34*(1+PPI)^(E$43-BaseYear)","v":18812.948945522752},19155.445685761562,19504.177706679326,19859.258523882414,20220.80371957106,14128.924021947436,14386.146344434545,14648.051495074949,14914.724726498744,15186.252843391907,15462.724230752039,15744.228882658546,16030.858431566541,16322.706178134098,16619.867121592528]
[null,"Office","m2 GFA","N/A",{"$f":"E35*$V35*(1+PPI)^(E$43-BaseYear)","v":9797161.3708875235},9975522.3414530214,10157130.439897371,10342044.781392632,10530325.557324558,10924028.404933687,11122904.409424007,11325401.025624217,11531584.168118563,11741520.951490849,11955279.71217086,12172930.03067854,12394542.754273091,12620190.020014454,12849945.278244607]
[null,"Retail","m2 GFA","N/A",{"$f":"E36*$V36*(1+PPI)^(E$43-BaseYear)","v":6474337.8523534667},6592205.5835665222,6712219.1407123795,6834417.589351112,6958840.7062458508,6562999.3174164584,6682481.1636125911,6804138.2213057866,6928010.0910312468,7054137.0942666698,7182560.2865572628,7313321.470879727,7446463.2112495126,7582028.846575819,7720062.5047688289]
[null,"Showroom, Retail Warehouse & Bulky Goods","m2 GFA","N/A",{"$f":"E37*$V37*(1+PPI)^(E$43-BaseYear)","v":1306132.6220470218},1329911.2527479327,1354122.782274327,1378775.0917105062,1403876.2056188444,1324025.0512733597,1348129.4203102812,1372672.6183603776,1397662.6344692232,1423107.6031259431,1449015.8069110648,1475395.6791925798,1502255.8068710822,1529604.9331748886,1557451.9605060436]
[null,"Warehouse, Bulk Stores & Logistics","m2 GFA","N/A",{"$f":"E38*$V38*(1+PPI)^(E$43-BaseYear)","v":1345409.0084461011},1369902.68038531,1394842.2687419793,1420235.8915905191,1446091.8147979053,1010481.9845641081,1028878.1853290929,1047609.2957785212,1066681.4130678955,1086100.7453537052,1105873.6138142403,1126006.4547071953,1146505.8214647314,1167378.3868266833,1188630.9450125985]
[null,"Rural","m2 GFA","N/A",{"$f":"E39*$V39*(1+PPI)^(E$43-BaseYear)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total","N/A","N/A",{"$f":"SUM(E44:E56)","v":36965268.25175038},{"$f":"SUM(F44:F56)","v":37638234.723670281},38323452.800779238,39021145.528111435,39731540.011318862,37576623.112628713,38260719.527418613,38957270.172151588,39666501.780720852,40388645.214794599,41123935.538963631,41872612.097257175,42634918.591051586,43411103.15839754,44201418.454791315]
[]
["Notes:"]
["(1) Growth figures are based on land use counts and growth rates sourced from LGIP planning assumptions."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) Planning Scheme zones exlude Priority Development Areas, Special Purpose Zones for Airport, Port and Southbank"]

{"sheet":"Growth (Impervious Area)","index":4,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"},null,null,"Input"]
[null,null,null,"Formula"]
[3.1,"Anticipated Impervious Area Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2021,2026,2031,2036]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2",68310898.856099099,70604374.165407389,72949608.38750641,75066714.188829347]
[]
[3.2,"Anticipated Non Residential Growth - Annualised (3)"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,null,"Charge Code","Applied Charge"]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2",{"$f":"D8","v":68310898.856099099},{"$f":"($E8-$D8)/5","v":458695.06186165812},{"$f":"($E8-$D8)/5","v":458695.06186165812},458695.06186165812,458695.06186165812,458695.06186165812,{"$f":"($F8-$E8)/5","v":469046.84441980423},{"$f":"($F8-$E8)/5","v":469046.84441980423},469046.84441980423,469046.84441980423,469046.84441980423,{"$f":"($G8-$F8)/5","v":423421.16026458738},{"$f":"($G8-$F8)/5","v":423421.16026458738},423421.16026458738,423421.16026458738,423421.16026458738,null,"T01",{"$f":"VLOOKUP(U13,'BAICR Charge Lookup'!A:F,6,FALSE)","v":10.91}]
[]
[2.2999999999999998,"Anticipated Revenue - Applied Charge"]
[]
[null,"Development type","Unit of demand",2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2","N/A",{"$f":"E13*$V13*(1+PPI)^(E$17-BaseYear)","v":5095469.4188902481},5188234.3368736031,5282688.0747283027,5378861.3780489117,5476785.5521649858,5702342.17578441,5806155.4382659001,5911858.6598439934,6019486.2479277328,6129073.2363258628,5633606.830438775,5736168.7403657977,5840597.8280502465,5946928.0861584069,6055194.1262057116]
[]
["Notes:"]
["(1) Growth figures are based on impervious area in non-residential city plan zones. Growth in centre, mixed use and residential zones have been excluded."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) Planning Scheme zones exlude Priority Development Areas, Special Purpose Zones for Airport, Port and Southbank"]

{"sheet":"BAICR Charge Lookup","index":5,"n_rows":133,"n_cols":7,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"}]
[]
["Charges categories, sub-categories, demand units, and applied adopted charge (AAC) rate - Lookup table"]
["Brisbane Adopted Infrastructure Charges Resolution (No.10) 2022"]
[]
["4.1 Reconfiguration of a Lot"]
["Code","Category","Sub Category","Demand Unit",null,"AICR10 Charge","Alt. Charge"]
["A01","01 Residential (Reconfiguration of a Lot)","Residential Lot","Number of residential lots",null,15270.71,0]
["A02","02 Non-Residential (Reconfiguration of a Lot)","Non-Residential Lot","Number of non-residential lots",null,15270.71,0]
[]
["4.2 Material Change of Use (Residential - Transport, Community Purposes, and Waterways)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR10 Charge","Alt. Charge"]
["B01","01 Residential (Material Change of Use/Building Work)","Caretaker's accommodation - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10907.66,0]
["B02","01 Residential (Material Change of Use/Building Work)","Caretaker's accommodation - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,15270.71,0]
["B03","01 Residential (Material Change of Use/Building Work)","Dwelling house - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10907.66,0]
["B04","01 Residential (Material Change of Use/Building Work)","Dwelling house - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,15270.71,0]
["B05","01 Residential (Material Change of Use/Building Work)","Dual occupancy - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10907.66,0]
["B06","01 Residential (Material Change of Use/Building Work)","Dual occupancy - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,15270.71,0]
["B07","01 Residential (Material Change of Use/Building Work)","Multiple dwelling - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10907.66,0]
["B08","01 Residential (Material Change of Use/Building Work)","Multiple dwelling - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,15270.71,0]
["C01","02 Residential Accommodation (short term)","Hotel (residential component) - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,5453.8,0]
["C02","02 Residential Accommodation (short term)","Hotel (residential component) - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,5453.8,0]
["C03","02 Residential Accommodation (short term)","Hotel (residential component) - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,7635.32,0]
["C04","02 Residential Accommodation (short term)","Short-term accommodation - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,5453.8,0]
["C05","02 Residential Accommodation (short term)","Short-term accommodation - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,5453.8,0]
["C06","02 Residential Accommodation (short term)","Short-term accommodation - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,7635.32,0]
["C07","02 Residential Accommodation (short term)","Resort complex (residential component) - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,5453.8,0]
["C08","02 Residential Accommodation (short term)","Resort complex (residential component) - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,5453.8,0]
["C09","02 Residential Accommodation (short term)","Resort complex (residential component) - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,7635.32,0]
["C10","02 Residential Accommodation (short term)","Tourist Park - 1 or 2 tent or caravan sites","Number of sites: 1 or 2 tent or caravan site",null,5453.8,0]
["C11","02 Residential Accommodation (short term)","Tourist Park - 3 or more tent or caravan sites","Number of sites: 3 or more tent or caravan site",null,7635.32,0]
["C12","02 Residential Accommodation (short term)","Tourist Park - 1 or 2 bedroom cabin","Number of cabins: 1 or 2 bedroom cabin",null,5453.8,0]
["C13","02 Residential Accommodation (short term)","Tourist Park - 3 or more bedroom cabin","Number of cabins: 3 or more bedroom cabin",null,7635.32,0]
["D01","03 Residential Accommodation (long term)","Community residence - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,10907.66,0]
["D02","03 Residential Accommodation (long term)","Community residence - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,10907.66,0]
["D03","03 Residential Accommodation (long term)","Community residence - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,15270.71,0]
["D04","03 Residential Accommodation (long term)","Relocatable home park - 1 or 2 bedroom relocatable dwelling site","Number of sites: 1 or 2 bedroom relocatable dwelling site",null,10907.66,0]
["D05","03 Residential Accommodation (long term)","Relocatable home park - 3 or more bedroom relocatable dwelling site","Number of sites: 3 or more bedroom relocatable dwelling site",null,15270.71,0]
["D06","03 Residential Accommodation (long term)","Retirement facility - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,10907.66,0]
["D07","03 Residential Accommodation (long term)","Retirement facility - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,10907.66,0]
["D08","03 Residential Accommodation (long term)","Retirement facility - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,15270.71,0]
["D09","03 Residential Accommodation (long term)","Rooming accommodation - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,10907.66,0]
["D10","03 Residential Accommodation (long term)","Rooming accommodation - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,10907.66,0]
["D11","03 Residential Accommodation (long term)","Rooming accommodation - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,15270.71,0]
[]
["4.3 Material Change of Use (Non-Residential - Transport, and Community Purposes)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR10 Charge","Alt. Charge"]
["E01","04 Non-Residential Places of assembly","Club","m2 GFA",null,37.1,0]
["E02","04 Non-Residential Places of assembly","Community use","m2 GFA",null,37.1,0]
["E03","04 Non-Residential Places of assembly","Function facility","m2 GFA",null,37.1,0]
["E04","04 Non-Residential Places of assembly","Funeral parlour","m2 GFA",null,37.1,0]
["E05","04 Non-Residential Places of assembly","Place of worship","m2 GFA",null,37.1,0]
["F01","05 Non-Residential Commercial (bulk goods)","Agricultural supplies store","m2 GFA",null,113.45,0]
["F02","05 Non-Residential Commercial (bulk goods)","Bulk landscape supplies","m2 GFA",null,113.45,0]
["F03","05 Non-Residential Commercial (bulk goods)","Garden centre","m2 GFA",null,113.45,0]
["F04","05 Non-Residential Commercial (bulk goods)","Hardware and trade supplies","m2 GFA",null,113.45,0]
["F05","05 Non-Residential Commercial (bulk goods)","Outdoor sales","m2 GFA",null,113.45,0]
["F06","05 Non-Residential Commercial (bulk goods)","Showroom","m2 GFA",null,113.45,0]
["G01","06 Non-Residential Commercial (retail)","Adult store","m2 GFA",null,157.05000000000001,0]
["G02","06 Non-Residential Commercial (retail)","Food and drink outlet","m2 GFA",null,157.05000000000001,0]
["G03","06 Non-Residential Commercial (retail)","Service industry","m2 GFA",null,157.05000000000001,0]
["G04","06 Non-Residential Commercial (retail)","Service station","m2 GFA",null,157.05000000000001,0]
["G05","06 Non-Residential Commercial (retail)","Shop","m2 GFA",null,157.05000000000001,0]
["G06","06 Non-Residential Commercial (retail)","Shopping centre","m2 GFA",null,157.05000000000001,0]
["H01","07 Non-Residential Commercial (office)","Office","m2 GFA",null,113.45,0]
["H02","07 Non-Residential Commercial (office)","Sales Office","m2 GFA",null,113.45,0]
["I01","08 Non-Residential Education facility ","Child care centre","m2 GFA",null,113.45,0]
["I02","08 Non-Residential Education facility","Community care centre","m2 GFA",null,113.45,0]
["I03","08 Non-Residential Education facility ","Educational establishment","m2 GFA",null,113.45,0]
["J01","10 Non-Residential Entertainment","Hotel (non-residential component)","m2 GFA",null,152.69,0]
["J02","10 Non-Residential Entertainment","Nightclub","m2 GFA",null,152.69,0]
["J03","10 Non-Residential Entertainment","Theatre","m2 GFA",null,152.69,0]
["K01","11 Non-Residential Indoor sport and recreational facility","Indoor sport and recreation (facility only)","m2 GFA",null,152.69,0]
["K02","11 Non-Residential Indoor sport and recreational facility","Indoor sport and recreation (court areas)","m2 GFA",null,16.32,0]
["L01","12 Non-Residential Industry","Low impact industry","m2 GFA",null,15.28,0]
["L02","12 Non-Residential Industry","Medium impact industry","m2 GFA",null,15.28,0]
["L03","12 Non-Residential Industry","Research and technology industry","m2 GFA",null,15.28,0]
["L04","12 Non-Residential Industry","Rural industry","m2 GFA",null,15.28,0]
["L05","12 Non-Residential Industry","Warehouse","m2 GFA",null,15.28,0]
["L06","12 Non-Residential Industry","Waterfront and marine industry","m2 GFA",null,15.28,0]
["M01","13 Non-Residential High impact industry","High impact industry","m2 GFA",null,32.71,0]
["M02","13 Non-Residential High impact industry","Noxious and hazardous industries","m2 GFA",null,32.71,0]
["N01","14 Non-Residential Low impact rural","Animal husbandry","m2 GFA",null,0,0]
["N02","14 Non-Residential Low impact rural","Cropping","m2 GFA",null,0,0]
["N03","14 Non-Residential Low impact rural","Permanent plantations","m2 GFA",null,0,0]
["N04","14 Non-Residential Low impact rural","Wind farms","m2 GFA",null,0,0]
["O01","15 Non-Residential High impact rural","Aquaculture","m2 GFA",null,10.88,0]
["O02","15 Non-Residential High impact rural","Intensive animal industries","m2 GFA",null,10.88,0]
["O03","15 Non-Residential High impact rural","Intensive horticulture","m2 GFA",null,10.88,0]
["O04","15 Non-Residential High impact rural","Wholesale nursery","m2 GFA",null,10.88,0]
["O05","15 Non-Residential High impact rural","Winery","m2 GFA",null,10.88,0]
["P01","16 Non-Residential Essential services","Correctional facility","m2 GFA",null,113.45,0]
["P02","16 Non-Residential Essential services","Emergency services","m2 GFA",null,113.45,0]
["P03","16 Non-Residential Essential services","Health care services","m2 GFA",null,113.45,0]
["P04","16 Non-Residential Essential services","Hospital","m2 GFA",null,113.45,0]
["P05","16 Non-Residential Essential services","Residential care facility","m2 GFA",null,113.45,0]
["P06","16 Non-Residential Essential services","Veterinary services","m2 GFA",null,113.45,0]
["Q01","17 Non-Residential Minor uses","Advertising device","m2 GFA",null,0,0]
["Q02","17 Non-Residential Minor uses","Cemetery","m2 GFA",null,0,0]
["Q03","17 Non-Residential Minor uses","Home based business","m2 GFA",null,0,0]
["Q04","17 Non-Residential Minor uses","Landing","m2 GFA",null,0,0]
["Q05","17 Non-Residential Minor uses","Market","m2 GFA",null,0,0]
["Q06","17 Non-Residential Minor uses","Outdoor lighting","m2 GFA",null,0,0]
["Q07","17 Non-Residential Minor uses","Park","m2 GFA",null,0,0]
["Q08","17 Non-Residential Minor uses","Roadside stalls","m2 GFA",null,0,0]
["Q09","17 Non-Residential Minor uses","Telecommunications facility","m2 GFA",null,0,0]
["Q10","17 Non-Residential Minor uses","Temporary use","m2 GFA",null,0,0]
["R01","Other uses","Brothel","m2 GFA",null," User Defined ",0]
["R02","Other uses","Car wash","m2 GFA",null," User Defined ",0]
["R03","Other uses","Environment Facility","m2 GFA",null," User Defined ",0]
["R04","Other uses","Major electricity infrastructure","m2 GFA",null," User Defined ",0]
["R05","Other uses","Nature-based tourism","m2 GFA",null," User Defined ",0]
["R06","Other uses","Substation","m2 GFA",null," User Defined ",0]
["R07","Other uses","Transport depot","m2 GFA",null," User Defined ",0]
["R08","Other uses","Other","m2 GFA",null," User Defined ",0]
["S01","Specialised uses","Air services","m2 GFA",null," User Defined ",0]
["S02","Specialised uses","Animal keeping","m2 GFA",null," User Defined ",0]
["S03","Specialised uses","Car park","m2 GFA",null," User Defined ",0]
["S04","Specialised uses","Crematorium","m2 GFA",null," User Defined ",0]
["S05","Specialised uses","Extractive industry","m2 GFA",null," User Defined ",0]
["S06","Specialised uses","Major sport, recreation and entertainment facility","m2 GFA",null," User Defined ",0]
["S07","Specialised uses","Motor sport","m2 GFA",null," User Defined ",0]
["S08","Specialised uses","Non-resident workforce accommodation","m2 GFA",null," User Defined ",0]
["S09","Specialised uses","Outdoor sport and recreation","m2 GFA",null," User Defined ",0]
["S10","Specialised uses","Port services","m2 GFA",null," User Defined ",0]
["S11","Specialised uses","Tourist attraction","m2 GFA",null," User Defined ",0]
["S12","Specialised uses","Utility installation","m2 GFA",null," User Defined ",0]
[]
["4.4 Material Change of Use (Non-Residential - Waterways)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR5 Charge","Alt. Charge"]
["T01","18 Non-Residential Stormwater","Stormwater impervious area","Impervious area in m2",null,10.91,0]

{"sheet":"Adopted Charge Revenue Forecast","index":6,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"2022-08-22"},null,null,null,null,null,null,null,"Input"]
[null,null,null,null,null,null,null,null,"Formula"]
[5.0999999999999996,"Anticipated infrastructure charges revenue ($'000)"]
[]
[]
[null,null,null,"Model year",null,0,1,2,3,4,5,6,7,8,9,10]
[null,"Development type",null,"2021 NPV",null,"2021 (1)",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,"Residential",null,{"$f":"F10+NPV(WACC,G10:P10)","v":451975.42843327235},null,0,{"$f":"HLOOKUP(G9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":53800.580963260669},{"$f":"HLOOKUP(H9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":54780.040571439538},{"$f":"HLOOKUP(I9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":55777.331606470638},{"$f":"HLOOKUP(J9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":56792.778696119072},{"$f":"HLOOKUP(K9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":57826.712378119206},{"$f":"HLOOKUP(L9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":66122.851686732116},{"$f":"HLOOKUP(M9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":67326.642821422312},{"$f":"HLOOKUP(N9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":68552.349421930994},{"$f":"HLOOKUP(O9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":69800.370467473214},{"$f":"HLOOKUP(P9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":71071.112200829157},{"$f":"HLOOKUP(Q9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":91733.853045156342},{"$f":"HLOOKUP(R9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":93403.90199540295},{"$f":"HLOOKUP(S9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":95104.354808603399},{"$f":"HLOOKUP(T9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":96835.764998403203},{"$f":"HLOOKUP(U9,'Growth (Residential)'!$E$40:$S$51,12,FALSE)/1000","v":98598.69615536982}]
[null,"Non-residential",null,{"$f":"F11+NPV(WACC,G11:P11)","v":284781.80819937127},null,0,{"$f":"HLOOKUP(G9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":36965.268251750378},{"$f":"HLOOKUP(H9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":37638.234723670284},{"$f":"HLOOKUP(I9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":38323.45280077924},{"$f":"HLOOKUP(J9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":39021.145528111432},{"$f":"HLOOKUP(K9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":39731.540011318859},{"$f":"HLOOKUP(L9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":37576.623112628717},{"$f":"HLOOKUP(M9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":38260.719527418616},{"$f":"HLOOKUP(N9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":38957.270172151591},{"$f":"HLOOKUP(O9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":39666.50178072085},{"$f":"HLOOKUP(P9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":40388.645214794597},{"$f":"HLOOKUP(Q9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":41123.935538963633},{"$f":"HLOOKUP(R9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":41872.612097257173},{"$f":"HLOOKUP(S9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":42634.918591051588},{"$f":"HLOOKUP(T9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":43411.103158397542},{"$f":"HLOOKUP(U9,'Growth (Non-Residential)'!$E$43:$S$57,15,FALSE)/1000","v":44201.418454791317}]
[null,"Non-residential (Stormwater)",null,{"$f":"F12+NPV(WACC,G12:P12)","v":40969.597566478173},null,0,{"$f":"HLOOKUP(G9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5095.4694188902477},{"$f":"HLOOKUP(H9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5188.2343368736028},{"$f":"HLOOKUP(I9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5282.688074728303},{"$f":"HLOOKUP(J9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5378.8613780489113},{"$f":"HLOOKUP(K9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5476.7855521649853},{"$f":"HLOOKUP(L9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5702.3421757844098},{"$f":"HLOOKUP(M9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5806.1554382659006},{"$f":"HLOOKUP(N9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5911.8586598439933},{"$f":"HLOOKUP(O9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":6019.4862479277326},{"$f":"HLOOKUP(P9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":6129.073236325863},{"$f":"HLOOKUP(Q9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5633.6068304387754},{"$f":"HLOOKUP(R9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5736.1687403657979},{"$f":"HLOOKUP(S9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5840.5978280502468},{"$f":"HLOOKUP(T9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":5946.9280861584066},{"$f":"HLOOKUP(U9,'Growth (Impervious Area)'!$E$17:$S$18,2,FALSE)/1000","v":6055.1941262057117}]
[null,"Total revenue",null,848085.87617912178,null,70359.041980000009,{"$f":"SUM(G10:G12)","v":95861.318633901305},{"$f":"SUM(H10:H12)","v":97606.509631983427},99383.472481978184,101192.78560227941,103035.03794160306,109401.81697514524,111393.51778710682,113421.47825392657,115486.3584961218,117588.83065194961,138491.39541455876,141012.68283302593,143579.87122770524,146193.79624295916,148855.30873636686]
[]
[null,"Notes:"]
[null,"(1) Actual charges revenue for 2020-2021 financial year"]

{"sheet":"LGIP Cash Flow Analysis","index":7,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council",null,null,null,"Input"]
[{"$f":"Coversheet!C8","v":"2022-08-22"},null,null,null,"Formula"]
[]
[6.1,"LGIP Summary Cash Flow Projections ($,000's)"]
[]
[]
[null,"Cost Category","Sub-category",null,"2021 NPV",null,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,"Anticipated Cost (Cap X in $'000)","Local Roads",null,{"$f":"G9+NPV(WACC,H9:Q9)","v":1523002.2445752709},null,null,188723.2378,188723.2378,188723.2378,188723.2378,188723.2378,229128.99619999999,229128.99619999999,229128.99619999999,229128.99619999999,229128.99619999999,245615.13480000003,245615.13480000003,245615.13480000003,245615.13480000003,245615.13480000003]
[null,null,"Pathway",null,588714.37907617085,null,null,84663.515800000008,84663.515800000008,84663.515800000008,84663.515800000008,84663.515800000008,72961.534799999994,72961.534799999994,72961.534799999994,72961.534799999994,72961.534799999994,1178.7868000000001,1178.7868000000001,1178.7868000000001,1178.7868000000001,1178.7868000000001]
[null,null,"Ferry Terminals",null,93169.30525430369,null,null,18973.064999999999,18973.064999999999,18973.064999999999,18973.064999999999,18973.064999999999,4118.7474000000002,4118.7474000000002,4118.7474000000002,4118.7474000000002,4118.7474000000002,4205.6001999999999,4205.6001999999999,4205.6001999999999,4205.6001999999999,4205.6001999999999]
[null,null,"Public Parks",null,522595.25947717909,null,null,64046.793400000002,64046.793400000002,64046.793400000002,64046.793400000002,64046.793400000002,79569.260800000004,79569.260800000004,79569.260800000004,79569.260800000004,79569.260800000004,92637.729000000007,92637.729000000007,92637.729000000007,92637.729000000007,92637.729000000007]
[null,null,"Land for Community Facilities",null,84785.819481237908,null,null,1636.0418,1636.0418,1636.0418,1636.0418,1636.0418,24575.696599999999,24575.696599999999,24575.696599999999,24575.696599999999,24575.696599999999,6240.6625999999997,6240.6625999999997,6240.6625999999997,6240.6625999999997,6240.6625999999997]
[null,null,"Stormwater",null,88537.989821362935,null,null,11571.8804,11571.8804,11571.8804,11571.8804,11571.8804,12519.7246,12519.7246,12519.7246,12519.7246,12519.7246,16036.305400000001,16036.305400000001,16036.305400000001,16036.305400000001,16036.305400000001]
[null,null,"Total Network Costs",null,2900804.9976855256,null,null,{"$f":"SUM(H9:H14)","v":369614.53420000005},369614.53420000005,369614.53420000005,369614.53420000005,369614.53420000005,422873.96039999998,422873.96039999998,422873.96039999998,422873.96039999998,422873.96039999998,365914.21880000003,365914.21880000003,365914.21880000003,365914.21880000003,365914.21880000003]
[null,"Anticipated Charges Revenue ($'000)","Residential",null,{"$f":"G16+NPV(WACC,H16:Q16)","v":451975.42843327235},null,{"$f":"'Adopted Charge Revenue Forecast'!F10","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G10","v":53800.580963260669},{"$f":"'Adopted Charge Revenue Forecast'!H10","v":54780.040571439538},{"$f":"'Adopted Charge Revenue Forecast'!I10","v":55777.331606470638},{"$f":"'Adopted Charge Revenue Forecast'!J10","v":56792.778696119072},{"$f":"'Adopted Charge Revenue Forecast'!K10","v":57826.712378119206},{"$f":"'Adopted Charge Revenue Forecast'!L10","v":66122.851686732116},{"$f":"'Adopted Charge Revenue Forecast'!M10","v":67326.642821422312},{"$f":"'Adopted Charge Revenue Forecast'!N10","v":68552.349421930994},{"$f":"'Adopted Charge Revenue Forecast'!O10","v":69800.370467473214},{"$f":"'Adopted Charge Revenue Forecast'!P10","v":71071.112200829157},{"$f":"'Adopted Charge Revenue Forecast'!Q10","v":91733.853045156342},{"$f":"'Adopted Charge Revenue Forecast'!R10","v":93403.90199540295},{"$f":"'Adopted Charge Revenue Forecast'!S10","v":95104.354808603399},{"$f":"'Adopted Charge Revenue Forecast'!T10","v":96835.764998403203},{"$f":"'Adopted Charge Revenue Forecast'!U10","v":98598.69615536982}]
[null,null,"Non-residential",null,284781.80819937127,null,{"$f":"'Adopted Charge Revenue Forecast'!F11","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G11","v":36965.268251750378},{"$f":"'Adopted Charge Revenue Forecast'!H11","v":37638.234723670284},{"$f":"'Adopted Charge Revenue Forecast'!I11","v":38323.45280077924},{"$f":"'Adopted Charge Revenue Forecast'!J11","v":39021.145528111432},{"$f":"'Adopted Charge Revenue Forecast'!K11","v":39731.540011318859},{"$f":"'Adopted Charge Revenue Forecast'!L11","v":37576.623112628717},{"$f":"'Adopted Charge Revenue Forecast'!M11","v":38260.719527418616},{"$f":"'Adopted Charge Revenue Forecast'!N11","v":38957.270172151591},{"$f":"'Adopted Charge Revenue Forecast'!O11","v":39666.50178072085},{"$f":"'Adopted Charge Revenue Forecast'!P11","v":40388.645214794597},{"$f":"'Adopted Charge Revenue Forecast'!Q11","v":41123.935538963633},{"$f":"'Adopted Charge Revenue Forecast'!R11","v":41872.612097257173},{"$f":"'Adopted Charge Revenue Forecast'!S11","v":42634.918591051588},{"$f":"'Adopted Charge Revenue Forecast'!T11","v":43411.103158397542},{"$f":"'Adopted Charge Revenue Forecast'!U11","v":44201.418454791317}]
[null,null,"Non-residential (Stormwater component)",null,40969.597566478173,null,{"$f":"'Adopted Charge Revenue Forecast'!F12","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G12","v":5095.4694188902477},{"$f":"'Adopted Charge Revenue Forecast'!H12","v":5188.2343368736028},{"$f":"'Adopted Charge Revenue Forecast'!I12","v":5282.688074728303},{"$f":"'Adopted Charge Revenue Forecast'!J12","v":5378.8613780489113},{"$f":"'Adopted Charge Revenue Forecast'!K12","v":5476.7855521649853},{"$f":"'Adopted Charge Revenue Forecast'!L12","v":5702.3421757844098},{"$f":"'Adopted Charge Revenue Forecast'!M12","v":5806.1554382659006},{"$f":"'Adopted Charge Revenue Forecast'!N12","v":5911.8586598439933},{"$f":"'Adopted Charge Revenue Forecast'!O12","v":6019.4862479277326},{"$f":"'Adopted Charge Revenue Forecast'!P12","v":6129.073236325863},{"$f":"'Adopted Charge Revenue Forecast'!Q12","v":5633.6068304387754},{"$f":"'Adopted Charge Revenue Forecast'!R12","v":5736.1687403657979},{"$f":"'Adopted Charge Revenue Forecast'!S12","v":5840.5978280502468},{"$f":"'Adopted Charge Revenue Forecast'!T12","v":5946.9280861584066},{"$f":"'Adopted Charge Revenue Forecast'!U12","v":6055.1941262057117}]
[null,null,"Total revenue",null,848085.87617912178,null,{"$f":"'Adopted Charge Revenue Forecast'!F13","v":70359.041980000009},{"$f":"SUM(H16:H18)","v":95861.318633901305},97606.509631983427,99383.472481978184,101192.78560227941,103035.03794160306,109401.81697514524,111393.51778710682,113421.47825392657,115486.3584961218,117588.83065194961,138491.39541455876,141012.68283302593,143579.87122770524,146193.79624295916,148855.30873636686]
[null,"Annual Cash Flow ($'000)","N/A",null,-2052719.1215064044,null,{"$f":"G19-G15","v":70359.041980000009},{"$f":"H19-H15","v":-273753.21556609875},-272008.02456801664,-270231.06171802187,-268421.74859772064,-266579.496258397,-313472.14342485473,-311480.44261289318,-309452.48214607342,-307387.60190387815,-305285.12974805036,-227422.82338544127,-224901.5359669741,-222334.34757229479,-219720.42255704087,-217058.91006363317]
[null,"Cumulative Cash Flow ($'000)","N/A",null,"N/A",null,{"$f":"G20","v":70359.041980000009},{"$f":"H20+G21","v":-203394.17358609874},{"$f":"I20+H21","v":-475402.19815411535},-745633.25987213722,-1014055.0084698579,-1280634.5047282549,-1594106.6481531095,-1905587.0907660027,-2215039.572912076,{"$f":"P20+O21","v":-2522427.1748159542},{"$f":"Q20+P21","v":-2827712.3045640048},{"$f":"R20+Q21","v":-3055135.127949446},{"$f":"S20+R21","v":-3280036.6639164202},{"$f":"T20+S21","v":-3502371.0114887152},{"$f":"U20+T21","v":-3722091.4340457562},{"$f":"V20+U21","v":-3939150.3441093895}]
[null,"Additional funding required","N/A",null,"N/A",null,{"$f":"G20","v":70359.041980000009},{"$f":"H20+G22","v":-203394.17358609874},{"$f":"I20+H22","v":-475402.19815411535},-745633.25987213722,-1014055.0084698579,-1280634.5047282549,-1594106.6481531095,-1905587.0907660027,-2215039.572912076,{"$f":"P20+O22","v":-2522427.1748159542},{"$f":"Q20+P22","v":-2827712.3045640048},{"$f":"R20+Q22","v":-3055135.127949446},{"$f":"S20+R22","v":-3280036.6639164202},{"$f":"T20+S22","v":-3502371.0114887152},{"$f":"U20+T22","v":-3722091.4340457562},{"$f":"V20+U22","v":-3939150.3441093895}]